from openpyxl import load_workbook
# from openpyxl import Workbook
#
# wb = Workbook()
# ws = wb.create_sheet('rig')
#
# ws['A1'] = 1
# ws.cell(5,5,'aaaaa')
# ws.cell(5,5).value = 'aaaaa'
# wa =ws.cell(5,5).value
# print(wa)
# wb.save('openpyxl1.xlsx')

wb = load_workbook('openpyxl1.xlsx',data_only=True)
ws = wb['rig']
wopen = ws.cell(5,5).value
print(wopen)
